/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : localhost:3306
 Source Schema         : student01

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : 65001

 Date: 28/06/2023 01:21:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for clazz
-- ----------------------------
DROP TABLE IF EXISTS `clazz`;
CREATE TABLE `clazz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clazz_code` varchar(36) DEFAULT NULL,
  `clazz_name` varchar(64) DEFAULT NULL,
  `year_code` varchar(10) DEFAULT NULL,
  `teacher_id` varchar(36) DEFAULT NULL,
  `teacher_name` varchar(64) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of clazz
-- ----------------------------
BEGIN;
INSERT INTO `clazz` VALUES (2, '202303', '2023级3班', '2023', '5', NULL, '2023-06-27 14:49:10');
INSERT INTO `clazz` VALUES (3, '202002', '2020年2班', '2020', '3', NULL, '2023-06-27 21:36:53');
INSERT INTO `clazz` VALUES (4, '202105', '2021年5班', '2021', '3', NULL, '2023-06-27 21:37:18');
INSERT INTO `clazz` VALUES (5, '202204', '2022年4班', '2022', '5', NULL, '2023-06-27 21:37:45');
COMMIT;

-- ----------------------------
-- Table structure for score
-- ----------------------------
DROP TABLE IF EXISTS `score`;
CREATE TABLE `score` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` varchar(36) DEFAULT NULL,
  `semester` int(11) DEFAULT NULL,
  `mid_marks` double DEFAULT NULL,
  `end_marks` double DEFAULT NULL,
  `create_user` varchar(36) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of score
-- ----------------------------
BEGIN;
INSERT INTO `score` VALUES (1, 'stu20230627150434', 1, 3333, 232, NULL, '2023-06-27 20:53:56');
INSERT INTO `score` VALUES (2, 'stu20230627150434', 1, 11, 232222, NULL, '2023-06-27 20:54:03');
INSERT INTO `score` VALUES (3, 'stu20230627150434', 1, 11, 232, NULL, '2023-06-27 20:57:25');
INSERT INTO `score` VALUES (4, 'stu20230627150434', 1, 1111, 23, NULL, '2023-06-27 20:59:00');
INSERT INTO `score` VALUES (6, 'stu2023213857', 1, 88, 88, NULL, '2023-06-27 22:06:03');
INSERT INTO `score` VALUES (7, 'stu20230627150751', 1, 111, 1111, NULL, '2023-06-27 22:06:23');
COMMIT;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` varchar(36) DEFAULT NULL,
  `chinese_name` varchar(50) DEFAULT NULL,
  `english_name` varchar(50) DEFAULT NULL,
  `tel` varchar(20) DEFAULT NULL,
  `stu_class` varchar(36) DEFAULT NULL,
  `class_name` varchar(64) DEFAULT NULL,
  `stu_status` varchar(4) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL,
  `password` varchar(36) DEFAULT NULL,
  `deleted` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of student
-- ----------------------------
BEGIN;
INSERT INTO `student` VALUES (8, 'stu20230627150434', '佳明', 'mingjia', '14788886666', '202002', '2020年2班', 'A', '2023-06-27 15:07:39', '2', 1);
INSERT INTO `student` VALUES (9, 'stu20230627150751', '路西', 'lucy', '18634343456', '202105', '2021年5班', 'A', '2023-06-27 15:08:04', '1', 0);
INSERT INTO `student` VALUES (10, 'stu2023213819', '张三', 'sanzhang', '18812341234', '202204', '2022年4班', 'A', '2023-06-27 21:38:19', '2', 0);
INSERT INTO `student` VALUES (11, 'stu2023213857', '李四', 'sili', '19888886666', '202303', '2023级3班', 'A', '2023-06-27 21:38:57', '1', 0);
INSERT INTO `student` VALUES (12, 'stu2023011247', NULL, NULL, NULL, NULL, NULL, NULL, '2023-06-28 01:12:47', NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
  `role` varchar(100) DEFAULT NULL COMMENT '角色',
  `token` varchar(200) NOT NULL COMMENT '密码',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='token表';

-- ----------------------------
-- Records of token
-- ----------------------------
BEGIN;
INSERT INTO `token` VALUES (14, 1, 'admin', 'users', '0', 'd0ywpafyhtqdxqcba8gthiw3v04je21b', '2023-06-11 08:47:15', '2023-06-27 09:12:02');
INSERT INTO `token` VALUES (15, 1, 'admin', 'users', '1', 'ndwv97fh7zrk553mi9mip2fgxv2pbtsg', '2023-06-27 11:22:37', '2023-06-28 02:20:31');
INSERT INTO `token` VALUES (16, 5, 'wangwu', 'users', '2', 'zn65cqjyvvs1v8c0fqzyktw5e7nig7cr', '2023-06-27 21:13:04', '2023-06-28 00:07:06');
INSERT INTO `token` VALUES (17, 10, '张三', 'users', '3', '2aceukgzc2uh92b1vp708e0kq62wpy05', '2023-06-27 23:26:09', '2023-06-28 01:12:53');
INSERT INTO `token` VALUES (18, 11, '李四', 'users', '3', '0bcir56zhb0qbvnkytxloco0yy9cuyjw', '2023-06-28 00:13:24', '2023-06-28 01:13:24');
COMMIT;

-- ----------------------------
-- Table structure for user_table
-- ----------------------------
DROP TABLE IF EXISTS `user_table`;
CREATE TABLE `user_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `sex` varchar(10) DEFAULT NULL COMMENT '性别',
  `identity` varchar(10) DEFAULT NULL COMMENT '身份 0-管理员 1-老师 2-学生',
  `create_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user_table
-- ----------------------------
BEGIN;
INSERT INTO `user_table` VALUES (1, 'admin', 'admin', '男', '1', NULL);
INSERT INTO `user_table` VALUES (3, 'lisi', '456', '男', '2', NULL);
INSERT INTO `user_table` VALUES (4, 'zgjiang2', '123', '女', '1', NULL);
INSERT INTO `user_table` VALUES (5, 'wangwu', '5', '女', '2', NULL);
INSERT INTO `user_table` VALUES (8, 'admin01', 'admin', '男', '1', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
